/*** 
This do file lists the scripts we use to produce the figures and tables that are
not in figstabs_external.do. 

These figures and tables are not externally replicable
because they are based on confidential data, so they code is intended for review
only.

***/

*-------------------------------------------------------------------------------
* Configuration
*-------------------------------------------------------------------------------

project figstabs, cd

project, uses(code/config_project.do) raw
include code/config_project.do 

*-------------------------------------------------------------------------------
* Build
*-------------------------------------------------------------------------------

* Appendix Figures *************************************************************

* Produce Appendix Figure 1a
project, do("code/figs/Spending/Spending - Plot Structural Break Example.do")

* Produce Appendix Figure 1b
project, do("code/figs/Small Business Revenue/Small Business Revenue - Merchants Series in Connecticut Before Break Detection Adjustment.do")

* Produce Appendix Figure 1c
project, do("code/figs/Employment/Employment - Before and After Quartile Threshold Adjustment.do")

* Produce Appendix Figure 2a 
project, do("code/figs/Spending/Spending - QSS, Affinity, Womply Spending Mix.do")

* Produce Appendix Figure 2b
project, do("code/figs/Spending/Spending - MRTS, Affinity, Womply Spending Mix.do")

* Produce Appendix Figure 6b
project, do("code/figs/Spending/Spending - Coinout vs Affinity Spending.do")

* Produce Appendix Figure 9b 
project, do("code/figs/Jobs/Jobs - Evolution of Low-Education Job Postings at National Level.do")

* Produce Appendix Figure 12a
project, do("code/figs/Small Business Revenue/Small Business Revenue - Change in Revenue in April 2020 vs Rent Binscatter with Sector FEs.do")

* Produce Appendix Figure 14a
project, do("code/figs/Employment/Employment - Benchmark Employment to CES Industries.do")

* Produce Appendix Figure 28a
project, do("code/figs/Employment/Employment - Change in Employment by PPP Eligibility.do")

* Produce Appendix Figure 28b
project, do("code/figs/Employment/Employment - Change in Employment by Firm Size.do")

* Appendix Tables **************************************************************

* Produce Appendix Table 3
project, do("code/tabs/Industry Employment Shares Across Datasets.do")

* Produce Appendix Table 7
project, do("code/tabs/Association Between Changes in Consumer Spending and Workplace Rent by ZIP Code.do")

* Produce Appendix Table 8
project, do("code/tabs/Demographic Characteristics of Zearn Users Panel A, B.do") 
project, do("code/tabs/Demographic Characteristics of Zearn Users Panel C.do")

** Notes: Appendix Tables 1, 2, 4, 9 are manually updated. 
*         Appendix Tables 5, 6, 10, 11 are produced in figstabs_external.do.
*         Appendix Table 12 is produced in Employment - Change in Employment by Firm Size.do.

* Scalars **********************************************************************
project, do("code/figs/Small Business Revenue/Small Business Revenue - Change in Revenue Controlling for Population (Safegraph).do")
project, do("code/figs/Employment/Employment - Earnin CPS Comparison.do")
